create procedure [dbo].[BAEEventSetupAddFunctionGroup] @eventCode varchar(15),
     @functionCode varchar(15),
     @groupName varchar(25),
     @functionorder int as
SELECT * FROM EventSetupFunctionGroup
    WHERE EventCode = @eventCode AND FunctionCode = @functionCode;
    IF (@@RowCount > 0)
        BEGIN
            UPDATE EventSetupFunctionGroup
            SET GroupName = @groupName, FunctionOrder = @functionorder
            WHERE EventCode = @eventCode AND FunctionCode = @functionCode;
        END
    ELSE
        BEGIN
            INSERT INTO EventSetupFunctionGroup(EventCode, FunctionCode, GroupName, FunctionOrder)
                VALUES(@eventCode, @functionCode, @groupName, @functionorder)
        END

GO